/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 80023
 Source Host           : localhost:3306
 Source Schema         : qq_for_java

 Target Server Type    : MySQL
 Target Server Version : 80023
 File Encoding         : 65001

 Date: 30/06/2021 20:50:47
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for chatInfo
-- ----------------------------
DROP TABLE IF EXISTS `chatInfo`;
CREATE TABLE `chatInfo` (
  `cno` int NOT NULL AUTO_INCREMENT COMMENT '编号',
  `csenderqq` int DEFAULT NULL COMMENT '发送者QQ',
  `creceiveqq` int DEFAULT NULL COMMENT '接受者QQ',
  `cdate` bigint DEFAULT NULL COMMENT '发送日期',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '消息内容',
  PRIMARY KEY (`cno`)
) ENGINE=InnoDB AUTO_INCREMENT=180 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of chatInfo
-- ----------------------------
BEGIN;
INSERT INTO `chatInfo` VALUES (108, 1001, 1002, 1623596492230, '1');
INSERT INTO `chatInfo` VALUES (109, 1001, 1002, 1623596587767, '2');
INSERT INTO `chatInfo` VALUES (110, 1002, 1001, 1623596596541, '3');
INSERT INTO `chatInfo` VALUES (111, 1002, 1001, 1623596600732, '4');
COMMIT;

-- ----------------------------
-- Table structure for friends
-- ----------------------------
DROP TABLE IF EXISTS `friends`;
CREATE TABLE `friends` (
  `fno` int NOT NULL AUTO_INCREMENT,
  `qq` int DEFAULT NULL,
  `fqq` int DEFAULT NULL,
  PRIMARY KEY (`fno`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of friends
-- ----------------------------
BEGIN;
INSERT INTO `friends` VALUES (11, 1001, 1002);
INSERT INTO `friends` VALUES (12, 1001, 1003);
INSERT INTO `friends` VALUES (13, 1001, 1004);
INSERT INTO `friends` VALUES (44, 1002, 1003);
INSERT INTO `friends` VALUES (45, 1002, 1004);
INSERT INTO `friends` VALUES (46, 1002, 1005);
INSERT INTO `friends` VALUES (47, 1001, 1005);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `qq` int NOT NULL AUTO_INCREMENT COMMENT 'qq号',
  `nickname` varchar(12) DEFAULT NULL COMMENT '昵称',
  `pwd` varchar(12) DEFAULT NULL COMMENT '密码',
  `sign` varchar(30) DEFAULT NULL COMMENT '签名',
  `avatarID` varchar(6) DEFAULT '1',
  PRIMARY KEY (`qq`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1020 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1001, '张三', '1001', '这是一条张三的签名', 'tx4006');
INSERT INTO `user` VALUES (1002, '李四', '1002', '这是一条李四的签名', 'tx3952');
INSERT INTO `user` VALUES (1003, '王五', '1003', '这是一条王五的签名', 'tx3953');
INSERT INTO `user` VALUES (1004, '小明', '1004', '这是一条小明的签名', 'tx3955');
INSERT INTO `user` VALUES (1005, '小红', '1005', '这是一条小红的签名', 'tx3956');
INSERT INTO `user` VALUES (1006, '小刚', '1006', '这是一条小刚的签名', 'tx4014');
INSERT INTO `user` VALUES (1007, '小强', '123123', '这是一条小强的签名', 'tx4021');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
